Database Insert as Flatstring
Type: Selection
Range: The settings listed below
Default: Default
When writing data to a database via the ODBC Driver, parameters can be used for each row, but for some vendors and ODBC drivers this can be slow. Therefor AIMMS offers an altenative flat-string technique for a few vendors. This alternative is currently available for MySQL, MS SQLServer and PostgreSQL. Based on performance experiments, the default for MySQL and Postgres is to using this flatstring technique, but for all three of these you can adjust this default by setting the option to On or Off explicitly.
Possible values are:
On
Default (which translates to: for MySql: On, for PostgreSQL: On, MS SQLServer: Off)
Off